<?php
declare(strict_types=1);
namespace App\Model\CommodityModel;

use App\Model\BaseModel\BaseCommodityModel;
use Hyperf\DbConnection\Db;

class Countryinfo extends BaseCommodityModel
{
    public $table = 'countryinfo_s2b';
    public function getCountryLists() {
        return self::query()
        ->where([
            ['IsDeleted','=',0]
        ])
        ->select([
            Db::raw('CONCAT(ID,"") as country_id'),
            Db::raw('CountryName as country_name'),
            Db::raw('CountryCode as country_code'),
        ])
        ->get()
        ->toArray();
    }
}